package com.user.mapper;

import com.user.pojo.Position;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author Administrator
 * @description 针对表【position(职位表)】的数据库操作Mapper
 * @createDate 2024-09-20 10:20:16
 * @Entity com.user.pojo.Position
 */
public interface PositionMapper extends BaseMapper<Position>
{
    @Select( "delete from `position` where id =#{id}")
    void deleteP(Integer id);

    @Select("UPDATE user SET `position_id` =NULL where position_id = #{id}")
    void upDeleteUser(Integer id);
}




